<?php

class m140203_152356_settings extends CDbMigration
{
	public function up() {
		$this->createTable('tbl_setting', array(
			'id'          => 'int not null primary key AUTO_INCREMENT',
			'name'        => 'varchar(30) not null',
			'value'       => 'text',
			'group'       => 'varchar(30)',
			'datatype'    => 'varchar(100)',
			'updated_at'  => 'timestamp default now()',
		));
	}

	public function down() {
		$this->dropTable('tbl_setting');
		return true;
	}

	/*
	// Use safeUp/safeDown to do migration with transaction
	public function safeUp()
	{
	}

	public function safeDown()
	{
	}
	*/
}